Business Intelligence Data Engineer
Golden State Foods
- Frisco, Texas, United States
- Frisco, Texas, United States
About
Job Summary The Data Engineer will be responsible for full cycle of DW development, including analyzing the business requirements and designing the ETL processing using dimensional modeling where applicable to present the data to the presentation layer for reporting consumption and post‑deployment production support. The Data Engineer will gather, collect, store, transform, and schedule (batch or real‑time) pipelines on the data and serve them to any visualization tools. The Data Engineer will evaluate BI/DW tools, incorporate them into the data platform, and educate others on best use.
What You’ll Do
Work with business requirements to identify and understand source data systems; provide resolutions to all data issues and coordinate with data analysts to validate all requirements, perform interviews with all users and developers.
Map source system data to data warehouse tables.
Develop and perform tests and validate all data flows and prepare all ETL/ELT processes according to business requirements and incorporate all business requirements into all design specifications.
Define and capture metadata and rules associated with ETL processes.
Adapt ETL processes to accommodate changes in source systems and new business user requirements.
Collaborate with all developers and business users to gather required data and execute all ETL programs and scripts on systems and implement all data warehouse activities and prepare reports for the same.
Provide support and maintenance on ETL processes and documentation.
Build partnerships across the application, business, and infrastructure teams.
Strive to continuously improve the software delivery processes and practices.
Champion company standards and best practices.
Additional Responsibilities
Accountable for properly following all IT standards, processes and methodologies as applicable including but not limited to Quality Assurance (QA).
Other responsibilities and accountabilities may be assigned based on business and organization needs.
Travel Expectations Regular travel requirements ( Management Responsibility N/A
Minimum Qualifications
Education/Certification: Four year college in a quantitative field such as Computer Science / Computer Information Systems or commensurate work experience.
Industry experience as a Business Intelligence Data Engineer or related specialty (e.g., Software Engineer, Business Intelligence Engineer, and Data Scientist) with extensive professional experience and a proven track record in a role focused on understanding, manipulating, processing and extracting value from various systems.
Strong proficiency in SQL.
Expert in ETL tools such as Matillion, Informatica, SSIS, ODI etc. and/or other data manipulation languages such as Python, SAS and R.
Creative in finding new solutions and designing innovative methods, systems and processes.
Desire to create and build new predictive/optimization tools for structuring datasets.
Extensive experience in Data Warehousing development: Star Schema modeling, slowly changing dimensions, row‑level security, standard DW architecture/processes, troubleshooting and production support.
Preferred Qualifications
Experience with AWS such as Redshift, EC2, S3, Python.
Strong analytic skills for working with structured and/or unstructured datasets.
Strong project management and organizational skills, experience working on complex initiatives with cross‑functional teams in a dynamic environment.
Experience with connecting data sets to data visualization tools and creating reports using PowerBI or other visualization tools.
Essential Knowledge, Skills and Abilities
Business Alignment
Requirements Definition
Communication Skills
Operational Process Flows
Analytical skills
Equal Opportunity Employer We’re proud to be an equal opportunity employer. Our company values diverse perspectives and is committed to creating an inclusive and respectful workplace where every person is supported and empowered to thrive.
#J-18808-Ljbffr
Languages
- English
Notice for Users
This job comes from a TieTalent partner platform. Click "Apply Now" to submit your application directly on their site.