Job DescriptionSOFTWARE DEVELOPER (GENERAL) ABOUT USBACKGROUNDALM First Financial Advisors is a SEC registered investment advisor to 250+ credit union/bank clients across the U.S. ALM First primarily provides asset/liability management (ALM) risk assessments, investment management ($20+ billion under management), and financial risk hedging services. Established in 1995, ALM First is headquartered in Dallas, TX. COMPANY CULTUREALM First is a cutting-edge, fast-paced working environment with a lot of opportunity for professional development. Other benefits include: weekly 1-1's; free parking; gym credit; snacks / stocked kitchen; 401K and company match; casual dress; company outings; job training and conferences. ABOUT THE JOBThis position is primarily responsible for providing technology design and support for in-house processes. Operating within the mortgage lending and banking industries, applicants should have experience with finance industry data. * This position reports to the ALM Strategy Group (ASG) in ALM First, responsible for development and execution of executive-level strategy. Candidate will work closely with ASG and the trading desk for development of databases, financial models and products.* Looking for a candidate with exceptional ability to dig deeply into large complex data, share best practices, and translate technical information into communications that non-technical users can understand.* Architect and design enterprise data solutions, including architecture definition, data modeling, design, and implementation of data warehousing solutions.* Create and implement solutions to move data through the use of ETL tools into a data warehouse. * Lead data warehousing projects focusing on financial performance, loan optimization, and other critical metrics.* Provide infrastructure, application support, and data integration for a variety of ALM First applications and systems, with a substantial amount of duties falling to data warehousing activities.* As solutions are developed, provide training and documentation. RESPONSIBILITIES ETL DEVELOPMENT & PROCESS OPTIMIZATION* Design and configure Extract, Transform, and Load (ETL) processes to ensure the data fits into a unified data architectural model that meets business requirements.* Develop streamlined data blending and data manipulation workflows to reduce manual processes.* Create and maintain documentation capable of translating complex technical information to a visual representation that non-technical users can understand. DATA ARCHITECTURE* Develop data warehouse or database system to ensure that information repository is accurate, accessible, and effective for internal users.* Analyze data holdings and develop schema in support of growth and extension.* Design a semantic layer capable of reporting by common data visualization tools. DATA QUALITY* Implement data quality / data cleansing processes, business rules, and error control / reporting within data integrations.* Maintain data and system integrity through data corrections, quality assurance, and testing.* Coordinate with other resources to identify, document, and resolve data or system issues that impact reporting and analytical deliverables. DATA ANALYSIS* Serve as financial data subject matter expert and reporting tool champion for Strategy Team.* Keep team members informed of new and/or modified data availability and functionality and conduct training as needed.* Perform database querying for testing, analysis, and reporting. PROJECT MANAGEMENT* Work with project managers to understand upcoming work and design a system capable of meeting long-term product vision* Take a lead role in facilitating discussions and resolving conflicts* Define user authorization requirements and participate in the resolution of problems, concerns and issues on an as needed basis.* Identify and implement options in overcoming potential bottlenecks or disruptions that could potentially cause projects to go off-track.* Independently prioritize work and meet project and customer timelines while delivering high-quality work. QUALIFICATIONS EDUCATION & EXPERIENCE* Bachelor's degree in business, economics, finance information systems, computer engineering, computer science, or other related field.* MBA or CFA candidacy a plus.* 3+ years developing software as part of a team, preferably in an analytical, information technology, or data-centric environment. SKILLS* Hands-on experience with modern enterprise data architectures and data tool sets (e.g. data warehouses, data marts, data lakes, modeling tools, data profiling tools).* Experience with management of large data (e.g., Microsoft SQL Server, SSIS, Alteryx, or equivalent knowledge of ETL functionality) required.* Experience with data analysis tools (e.g. Advanced Excel / VBA, Python / R) required.* Experience with data visualization tools a plus.