MW Partners is currently seeking a Business Intelligence Data Engineer to work for our client who is a leading business-to-business foodservice organization.
The Business Intelligence Data Engineer will be responsible for the scripts and processes required to extract, transform, clean and move data and metadata so they can be loaded into a data warehouse, data mart or operational data store. Reads, analyzes and digests what the company wants to accomplish with its data, and designs the best possible ETL process around those goals.
Only locals, GC holders or US Citizens will be considered for this role.
Responsibilities and duties:
Collect and document business requirements using interviews, document analysis, requirements workshops, surveys, site visits, business process descriptions, user stories, use cases, scenarios, business-process and workflow analysis.Critically evaluate information gathered from multiple sources and reconcile conflicts.Proactively communicate and collaborate with external and internal customers to understand processes, analyze information needs and define functional requirements.Serve as the conduit between the business unit and the BI development team.Successfully engage in multiple initiatives simultaneously and able to meet project deliverable deadlines.Work independently with users to define concepts.Review and edit requirements, specifications, business processes and recommendations related to proposed solution.Lead and perform complex analysis in an evolving data environment.Extract and analyze data, patterns, and related trends as needed, with the subsequent ability to synthesize the data into information consumable by organization.Provide data extraction, reports, dashboards, analysis and consultation services across organization.Design and roll out Business Intelligence solutions to end users.Ensure high levels of Business Intelligence availability through support functions and in-depth testing.Participate in strategic design, implementation, and maintenance of Business Intelligence software and systems, including integration with databases and data warehouses. Business Intelligence Data Engineer Analyst TasksProvide application analysis and data modelling design to collect data for centralized data warehouse.Extract data from databases and data warehouses for reporting and to facilitate sharing between multiple data systems.Proficient in the use of query and reporting analysis tools.Standardize data collection by developing methods for database design and validation reports.Work with business requirements to identify and understand source data systems; provide resolutions to all data issues and coordinate with data analyst to validate all requirements, perform interviews with all users and developers.Map source system data to data warehouse tablesDevelop and perform tests and validate all data flows and prepare all ETL processes according to business requirements and incorporate all business requirements into all design specifications.Define and capture metadata and rules associated with ETL processesAdapt ETL processes to accommodate changes in source systems and new business user requirementsCollaborate 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 same.Provide support and maintenance on ETL processes and documentationBuild partnerships across the application, business, and infrastructure teamsStrive to continuously improve the software delivery processes and practicesChampion company standards and best practicesAccountable for properly following all IT standards, processes and methodologies as applicable including but not limited to Quality Assurance (QA)
Four-year college or commensurate work experience.Knowledge of AWS Infrastructure including S3, Redshift and RDSExpertise in MS ExcelExpertise in SQL and relational databasesStrong communication (verbal and written) and interpersonal skills to translate key insights from complex analyses into actionable business insightsProven ability of looking at solutions in unconventional ways- seeing opportunities to innovate and leading the wayStrong proficiency in SQLCreative in finding new solutions and designing innovative methods, systems and processesAdvanced degree in Science and Technology related fieldExperience with building multi-dimensional data models to serve as a foundation for future analysesExperience with predictive modelingExperience with IoT, Machine Learning, and AI- Strong analytic skills for working with unstructured datasetsExperience with connecting data sets to data visualization tools and creating reports using Tableau andPower BIStrong project management and organizational skills, experience working on complex initiatives with cross- functional teams in a dynamic environmentExperience with Dell BoomiExperience with data visualization tools like Tableau and Microsoft Power BIDesire to create and build new predictive/optimization tools for structuring datasetsExpert in ETL and/or other data manipulation languages such as Python, SAS and RIndustry experience as a Data Engineer or related specialty (e.g. Software Engineer, Business IntelligenceEngineer, and Data Scientist) with extensive professional experience and a proven track record in a rolefocused on understanding, manipulating, processing and extracting value from large disconnected datasets.3+ years of analysis experience
Company DescriptionMW Partners is a rapidly growing Women and Minority owned company that provides Professional and IT Staffing Services on a contract, contract to hire and direct hire basis.