EDW Data Warehouse Developer

Full-time - Mid Level

Austin, TX

Professional, Scientific, and Technical Services

About the position

Allied Consultants, Inc. is an Austin-based firm which has for 33 years been a premier provider of technical and business professionals to clients in Texas. We are currently seeking an experienced EDW Data Warehouse Developer to be a key resource on a technical services team. Allied Consultants offers its family of consultants excellent rates, a local support staff, and an attractive benefits package which includes medical insurance (Allied shares a percentage of the cost), life insurance, a matching 401(k) plan and a cafeteria plan. Candidates selected for interview will be required to undergo criminal background checks and may be required to complete a drug screen in accordance with Federal and State Law. Offers of Employment are contingent on a successful background check. Allied Consultants is an equal opportunities employer.

Responsibilities

• Performs highly advanced (senior-level) data warehouse development work as a key member of a small but essential data management team.
• Collaborates closely with the data management team to develop and enhance the enterprise data warehouse using SQL Server and data warehouse automation tools.
• Contributes to the agency's ongoing process improvements within its data management program, focusing on areas such as data quality, reporting, and change management activities.
• Performs advanced data warehouse architectural work including data warehouse design, data modeling, and metadata design.
• Works closely with business SMEs to reverse engineer the rules that govern business processes, corresponding data streams, and associated source systems.
• Translates business needs into high level technical designs for business intelligence solutions.
• Applies rapid iterative development methodologies as appropriate to ensure the solution keeps pace with business needs.
• Performs in-depth, thorough, and accurate reporting or ad hoc analysis as needed.
• Contributes to the long-term vision of the Enterprise Data Warehouse (EDW) by delivering Agile solutions.
• Develops efficient ETL for loading the data warehouse and makes timely data available for business users.
• Assists in capturing processes, procedures and other metadata in documentation; ensures that documentation is well organized, complete, and appropriate for the audience.
• Troubleshoots, supports and maintains the data warehouse and associated tools used by the team (i.e. SQL servers).
• Contributes to and follows best practices established by the governance council, data stewards and enterprise data officer.
• Develops and improves continuous release and testing processes.
• Designs, deploys, and manages standardized, centralized data sources for agency reporting.
• Helps to establish best practices for development, testing, migration and error handling.
• Implements and maintains business intelligence security best practices including those related to HIPAA.
• Performs other duties as assigned.

Requirements

• Bachelor's degree in computer science, engineering, statistics, economics, finance, library science, or related business field.
• 3 years of hands-on experience in data warehouse development (i.e. WhereScape, etc.).
• 3 years of hands-on experience in SQL server ETL development (creating automated processes and troubleshooting issues) using services like SSIS, SSRS, SSAS.
• 3 years of hands-on experience moving and manipulating large data sets.
• 2 years of hands-on experience in dimensional modeling for data warehouses.
• 3 years of hands-on experience around documentation of standards, best practices, and governance as it relates to data warehouse development.
• 2 years of hands-on experience in Generative AI and Alteryx.

Nice-to-haves

• Experience in health/life insurance, benefits, accounting and financials, or investment data related activities.
• Experience with data tools (i.e. Alteryx, Visual Studio, SSIS, MSSQL, WhereScape).
• Experience with Azure and agile iterations.
• Experience with ERP applications (i.e. PeopleSoft, Safyr, etc.).
• Knowledge of health care claims data (i.e. HIPPA data).
• Experience troubleshooting performance in SQL servers.
• Experience with development and troubleshooting of Alteryx workflows.

Benefits

• Medical insurance (Allied shares a percentage of the cost).
• Life insurance.
• Matching 401(k) plan.
• Cafeteria plan.