Senior Database Developer / Engineer

The Intersect Group is seeking a Senior Database Developer/Engineer for our direct healthcare client, where you will be responsible for designing and building databases/data warehouses to store and manage healthcare claims and financial data. This position will analyze data, develop, test, and implement processes to load it, and assist with reporting. This person will have a strong understanding of RDBMS/Data Warehouse concepts, along with knowledge of claims or financial data.

Direct Hire

Location: Fully remote but would like someone local to Dallas who can easily come in for occasional meetings in Addison (75001)

Interview process: 1st is virtual interview; 2nd is onsite interview

Needs:

• Bachelor’s degree in Computer Science or equivalent combinations of education and experience
• 6 years’ experience in designing/modeling, and building data warehouses and data marts
• 6 years' experience building database objects in SQL Server: complex queries, stored procedures, tables, views, functions, indexes, etc.
• 2 years’ experience working with Healthcare claims (835/837 files) or Financial data
• Demonstrated knowledge of data warehousing concepts and methodologies, technologies, and tools
• Experience working with Azure SQL and Azure Data Factory data pipelines highly desired
• Experience building Power BI dashboards strongly preferred
• Demonstrated ability to understand, discuss and document complex data models
• Excellent communications skills, both written and oral
• Ability to manage and complete multiple concurrent projects in a timely manner
• Excellent problem solving and analytical skills

Preferred:

• Experience working with Azure DevOps
• Experience with cloud data warehousing and tools like Snowflake and dbt highly desired

Duties:

• Analyze Healthcare data, architect and design data models, and create databases/data warehouses
• Design and develop ETL processes necessary to load this data to the Enterprise Data Warehouse (EDW)
• Implement, schedule, monitor and support all related processes, applications and databases
• Build indexes and fine tune queries to ensure performance needs are met
• Collaborate closely with reporting team to create data mart to support reporting and analysis needs
• Perform advanced data analysis, identify issues and data gaps, and help provides insights
• Implement and support Master Data Management processes
• Ensure flexibility, scalability, consistency and quality when build solutions
• Follow best practices for development, QA, deployment, source code management
• Manage source code, conduct code reviews, and test
• Monitor and support processes/jobs and follow up on issues.
• Coordinate closely with other developers to streamline processes and optimize
• Gain strong knowledge of underlying data and business rules, and assist other teams
• Adopt agile methodology, and assist in tracking and communicating progress of deliverables