US National – 100% Remote Work
Data Warehouse Developer
Department: Business Intelligence
Who We Are:
Cardinal Financial is a nationwide direct mortgage lender whose mission is to prove that homeownership is possible for everyone. By bringing an open-minded approach to an often closed-minded industry, we’re able to embrace every unique financial situation differently in order to craft the best possible loans for our borrowers. We pride ourselves on providing excellent service backed by our groundbreaking technology, and these two components of our process come together to complete a simple, personalized mortgage experience. But it all starts with our people.
We believe that no matter where you fit in our organization?Sales, Human Resources, Information Technology, or even re-stocking the break rooms with endless coffee supplies?everyone can influence the experience that we provide to our customers and our partners. We tell our customers and our partners that anything can be reimagined. So why not your career? Looking to join a company that values its people, innovates and expands on its proprietary technology, and is growing at a ridiculous rate?! Apply below!
Who We Need:
Cardinal Financial is in search of a Data Warehouse Developer. Within this position, you’ll be focused on expanding, maturing, and maintaining the Firm’s data analytics platform. The Data Warehouse Developer is responsible for the development of the extraction, transformation, and loading of the data warehouse structures, as well as the business intelligence reporting implementation. This position will collaborate with an advanced line of business users in order to maintain accurate metadata and support early-stage analytics for new datasets and report requirement examples.
What You Will Do:
Develop and support an ETL process for data warehouse structures that support the reporting and data analytic systems.
Collaborate with a diverse team of business analysts and report developers to develop and build EDW artifacts, such as SQL code, logical and physical data models, and business intelligence reports.
Contribute to software design and architecture while following development specifications and standards.
Perform both analyst and developer responsibilities as needed within the full stack supporting the data warehouse.
Perform complex analysis and design across multiple database platforms and technologies.
May need to instruct and guide those with less experience.
To conduct research into new data warehouse applications and determine viability for adoption.
Identify and describe BI problems and requirements from across the organization.
Collaborate with data providers to ensure the right data is in the warehouse and is updated as changes occur in the data providers’ source system applications.
Profile and understand large volumes of source data, including structured and unstructured data. Sources will include MySQL, Microsoft SQL Server, flat files, web application API’s and the Cloud.
Regularly conduct ETL and database performance tuning. Look for ways to improve overall performance.
Identify opportunities to leverage existing metrics and develop new metrics to help move the organization forward by identifying waste in our processes.
Provide insight into creating and maintain a system that helps ad-hoc metrics providers move to a more robust and shareable reporting interface.
Assist in the development of metrics and processes to ensure quality standards are met on new and existing data.
What You Need:
Bachelor’s degree in Information Systems or a related field.
At least 5 years of recent experience required in full stack data warehouse development.
At least 5 years of recent business intelligence semantic layer design and report development using one or more tools like Tableau, OBIEE, Microstrategy, Business Objects, etc.
Expert level experience SQL coding/querying skills with a maj…
Database Administration , SQL , Software Development