Department is Data Analytics
Reports to Director of Data Analytics and Transformation
FLSA Status is Exempt
Objective and Purpose:
The Data Engineer will play a crucial role in shaping the strategic design and maintenance of our business intelligence infrastructure. This role focuses on enhancing the efficiency and effectiveness of data storage, reporting, and analysis processes. By collaborating with cross-functional teams, the Data Engineer will transform raw data into actionable insights that drive informed decision-making. The position requires expertise in Microsoft BI tools, SQL, Azure, and data governance, with a strong emphasis on ensuring data integrity and developing ETL processes that meet the evolving needs of the business. The ultimate goal is to optimize the use of data to improve business outcomes and support strategic initiatives.
Primary Responsibilities:
- Lead the strategic design, implementation, and maintenance of business intelligence infrastructure.
- Analyze, evaluate, and recommend improvements for data storage and reporting processes.
- Develop, write, and optimize ETL processes, reports, and dashboards.
- Collaborate with cross-functional teams, including subject matter experts and systems professionals, to transform data into actionable insights.
- Identify and leverage opportunities to enhance data availability and improve business intelligence processes.
- Conduct data audits, uncover integrity issues, and work with business managers to resolve them.
- Translate user requirements into technical and functional specifications for data solutions.
- Ensure adherence to data governance processes and best practices.
- Manage multiple projects and priorities effectively, while working independently with minimal supervision.
- Maintain comprehensive documentation for all processes, tools, and systems.
- Communicate complex data concepts clearly and effectively, both verbally and in writing.
Requirements:
- 5+ years of experience in business intelligence or data analysis roles, with a strong focus on Microsoft Business Intelligence tools (SSIS, SSRS, SSAS).
- Proficiency in Microsoft SQL Server 2019, with a deep understanding of SQL for ad-hoc reporting, data mining, and database optimization.
- Expertise in Microsoft PowerBI for creating insightful and interactive data visualizations.
- Hands-on experience with Microsoft Azure platform, particularly DataBricks and DataFactory, for managing large-scale datasets.
- Strong programming skills in PySpark and Python for developing and maintaining efficient ETL processes.
- BA/BS degree in software development, information systems, engineering, mathematics, or a related field.
- Proven ability to work with large datasets, ensuring data integrity, accuracy, and accessibility.
- Comprehensive knowledge of data modeling and best practices in Data Warehouse development.
- Expertise in developing and modifying ETL processes, including utilizing API calls for data extraction and integration.
- Familiarity with data governance processes, ensuring compliance with industry standards.
- Strong project management skills, with the ability to manage multiple projects and priorities simultaneously.
- Ability to work independently with minimal supervision, demonstrating a proactive approach to problem-solving.
- Excellent documentation skills for processes, systems, and tools.
- Superior verbal and written communication skills for effective collaboration with technical and non-technical stakeholders.
Work Conditions:
- Candidate must be able to work in office 5 days a week
- Candidate must be able to travel as required for business needs.
- Candidate must be able to lift up to 25 lbs as needed.
- Candidate must be able to sit or stand for extended periods of time.
Salary: $115,000 to $130,000 / annum
Location: 1800 West Loop S., Suite 2000 Houston, TX 77027
Modality: In Person
We believe in transparency through the talent acquisition process; we support our team members, past, future, and present, to make the best decision for themselves and their families. Starting off on the right foot with pay transparency is just one way that we are supporting this mission.
Position Base Pay Range: $115,000 USD - $130,000 USD
Specialty1 Partners is the direct employer of non-clinical employees only. For clinical employees, the applicable practice entity listed above in the job posting is the employer. Specialty1 Partners generates job postings and offer letters to assist with human resources and payroll support provided to the applicable practice. Clinical employees include dental assistants and staff assisting with actual direct treatment of patients. Non-clinical employees include the office manager, front desk staff, marketing staff, and any other staff providing administrative duties.
Specialty1 Partners and its affiliates are equal-opportunity employers who recognize the value of a diverse workforce. All suitably qualified applicants will receive consideration for employment based on objective criteria and without regard to the following (which is a non-exhaustive list): race, color, age, religion, gender, national origin, disability, sexual orientation, gender identity, protected veteran status, or other characteristics in accordance with the relevant governing laws. Specialty1 Partners' Privacy Policy and CCPA statement are available for view and download at https://www.specialty1partners.com/privacy-policy/
Specialty1 Partners and all its affiliates participate in the federal government’s E-Verify program. Specialty1 further participates in the E-Verify Program on behalf of the clinical practice entities which are supported by Specialty1. E-Verify is used to confirm the employment authorization of all newly hired employees through an electronic database maintained by the Social Security Administration and Department of Homeland Security. The E-Verify process is completed in conjunction with a new hire’s completion of Form I-9, Employment Eligibility Verification upon commencement of employment. E-Verify is not used as a tool to pre-screen candidates. For up-to-date information on E-Verify, go to www.e-verify.gov and click on the Employees Link to learn more.
Specialty1 Partners and its affiliates uses mobile messages in relation to your job application. Message frequency varies. Message and data rates may apply. Reply STOP to opt-out of future messaging. Reply HELP for help. View our Privacy & SMS Policy here.
By submitting your application you agree to receive text messages from Specialty1 and its affiliates as outlined above.