BI Data Developer Mid-Level

Title: BI/Data Developer - Mid-Level
Location: 100% Remote
Duration: 1 year contract with potential to extend and/or convert

Notes:

• Chose the best title for the job but a cross between a developer (VBA coding) and Data Engineer (Power BI dashboard creation)
• 5-10 years of experience in a developer/programmer role AND business intelligence, data analyst or reporting analyst role
• Combination of both types of experience to make up the 5-10 years experience
• Likely 2 year assignment

Job Summary:

The BI/Data Developer plays a meaningful role in transforming raw data into actionable insights that drive business decisions at our International Global Buying & Sourcing Offices (GBOs).

Major Areas of Responsibility

• Extract, enrich and consolidate data from a variety of sources for reporting.
• Ensure accuracy and completeness of data input and output.
• Identify and resolve data discrepancies between source systems and reporting output.
• Build and maintain MS Access databases to consolidate, enrich, and transform data.
• Design relational database structures, queries, forms, and modules to support notifications and reporting workflows.
• Integrate supplementary data including manual inputs, flat files, and external feeds to produce comprehensive, analysis-ready datasets.
• Develop, maintain, and enhance Excel VBA modules that support custom Excel-based tools.
• Build automated report generation pipelines to distribute reports via email or shared drives.
• Partner with associates at the GBOs to understand needs and deliver solutions.
• Translate business requirements into functional solutions that are intuitive, accurate, and maintainable.
• Proactively identify opportunities to streamline manual processes through automation and improved data workflows.
• Support ad-hoc analysis and special projects as assigned.
• Responsible for decisions that directly impact solution delivery timelines.
• Responsible for project decisions on new features and functionality enhancements, as well as release strategy.
• Responsible for determining project scope and completion criteria.

Required:

• 5-10 years of experience in a developer/programmer role AND business intelligence, data analyst or reporting analyst role.
• Bachelor's or Associate s degree in Computer Science, Information Systems, Computer Science, Business Analytics, Data Science, OR a related field.
• Proficient in programming with Excel VBA, including event-driven programming using UserForms, ADO/DAO database connectivity, and workbook automation.
• Proficient in Microsoft Access, including relational data model design, forms, data import/export automation, and VBA.
• Proficiency writing raw SQL queries to extract, filter, augment, and aggregate data.
• Experience with Microsoft 365 automation (Power Platform, SharePoint integration, Power BI).
• Solid understanding of data modeling concepts, data cleansing, and ETL fundamentals.
• Strong analytical and problem-solving skills with high attention to detail.
• Detail-oriented, comfortable digging into code and working with imperfect data sets.
• Superb communication skills and a can do demeanor.
• Proven experience supporting non-technical people and maintaining solutions.
• Ability to identify and implement process improvements through automation.
• Skills in creating and maintaining technical documentation for data solutions and processes.
• Excellent teamwork, interpersonal, and communication skills.

List specific jobs which could prepare an individual for this job.

• Data Architect
• Data Engineer
• Automation Engineer
• Business Intelligence Analyst
• IT Support Engineer
• Data Analyst
• Process Improvement Analyst

Why TalentBurst?
At TalentBurst, we deliver more than talent, we deliver outcomes. We partner with you to move quickly and connect you to opportunities aligned with your skills and long term growth.

Backed by precision, transparency, and results, we connect top talent with leading organizations through trusted partnerships.

We offer competitive compensation and comprehensive benefits, including medical, dental, vision, and retirement options.

TalentBurst is an equal opportunity employer committed to an inclusive and diverse workforce.