EDW Data Warehouse Developer

Allied Consultants-posted 10 months ago
Full-time • Mid Level
Austin, TX
Professional, Scientific, and Technical Services
Resume
Match Score
Upload and Match ResumeTrack Jobs with Teal

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.

  • 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.
  • 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.
  • 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.
  • Medical insurance (Allied shares a percentage of the cost).
  • Life insurance.
  • Matching 401(k) plan.
  • Cafeteria plan.
Track Jobs with Teal

Job Search Resources

•
AI Resume Builder
•
Data Warehouse Developer Resume Examples
•
Data Warehouse Developer Cover Letter Examples

Tools

Career Hubs

Guides

Company

© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service