Avantiico · 3 weeks ago
Microsoft BI Engineer (Microsoft Dynamics 365 F&O)
United States
Full-time
Hybrid
Mid, Senior Level
$110K/yr - $140K/yr
5+ years expAvantiico is a business automation company and Microsoft Partner delivering integrated Microsoft Cloud solutions. The Microsoft BI Engineer will provide technical expertise, develop and support data solutions, and work closely with clients to deliver actionable insights using Microsoft tools.
Information and Communications Technology (ICT)Information ServicesInformation Technology
Responsibilities
Develop Code in ETL tools, for the extraction, transformation, and loading of data from source systems to the data stores
Designs and constructs operational data stores, data lakes, and data marts
Designs key and indexing schemes and designs partitioning
Identifying, designing and implementing internal process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes
Building with analytical tools to provide actionable insights into key business performance metrics including operational efficiency
Working with stakeholders including data, design, product and others to assist them with data-related technical issues
Provide support for front-end development, delivery and support of Business Intelligence and Analytical solutions
Develop complex back-end data schemas to support front-end reporting requirements
Assist management with evaluating and accepting new projects by providing cost estimates, application analysis and recommendations based on application and project experience
Meet with decision makers, systems owners, end users and business analysts to define business requirements and systems goals and identify and resolve business data issues. Responsible for setting development standards and practices. Manage and maintain responsibility for assigned projects
Assist employees in solving routine data, system software, hardware, and procedure problems
Regularly evaluate existing development footprint and identify areas to improve software. Evaluate industry best practices to determine fit within the customer’s infrastructure
Assist with periodic testing and implementation of contingency plans to ensure availability of data in case of system failure
Follow internal project management methodology by adhering to documentation and production change control processes when implementing application enhancements and maintenance to ensure a stable production environment
Participate in proactive team efforts to achieve departmental and company goals
Must comply with current applicable laws, regulations and bank policies and procedures. Comply with all safety policies, practices and procedures. Report all unsafe activities to supervisor and/or Human Resources
Self-motivated with ability to work effectively with limited supervision, enthusiasm for collaboration, continuous learning, and a team player
Understand importance of code review and automated testing and different levels at which these need to be performed and write and implement tests as required
Stay current with Microsoft updates, new features, and best practices
Additionally, this role will assist in pre-sales/marketing activities including but not limited to producing written content, short videos, webinars, and in-person presentations
Qualification
Required
At least 5 years of information technology experience
3 years of experience working on Azure services such as Azure Data Lake Gen 1 and 2, Synapse Analytics (2 years), Azure Data Factory, Azure SQL Database, Azure SQL DW, Rest APIs
5 or more years of T-SQL language/query experience with data manipulation such as stored procedures, functions etc. Knowledge of data models, data modeling (Relational and Dimensional), Data profiling and working with large data environments
3 or more years with Dynamics 365 Finance & Supply Chain
3 or more years querying data sources using tools like Excel (PowerPivot, Power Query, Power Map), Power BI, and other reporting tools such as Tableau, SAS, and Teradata
Strong communication, team player and advance analytical skills to analyze data issues and drive appropriate actions with data operations and business processes
Experience in solving ambiguous requests and problems using data
Self-motivated with ability to work effectively with limited supervision, enthusiasm for collaboration, continuous learning, and a team player
Understand importance of code review and automated testing and different levels at which these need to be performed and write and implement tests as required
Stay current with Microsoft updates, new features, and best practices
Additionally, this role will assist in pre-sales/marketing activities including but not limited to producing written content, short videos, webinars, and in-person presentations
Preferred
Experience with Microsoft Fabric is highly desirable. However, experience with prior applicable tools is required: Synapse Analytics, Data Factory, Power Query, advanced T-SQL and SSMS are required
Python, Java or R; C++
Knowledge or experience in implementing solutions with Microsoft PowerApps, Power Automate, and/or Common Data Service (Power Platform)
Data Governance, Data Quality, Master Data Management, Insurance domain knowledge
Data Science background or skills are not required but please mention them as appropriate
Current Microsoft certification a plus, or the ability to obtain after joining within 90 days of employment
Benefits
99% of employee healthcare paid for by the company
Choices of premium HMO/PPO plans
Matching 401k plan
Paid Vacation/Sick/Holidays
Company
Avantiico
Avantiico is a full service Microsoft Dynamics Gold Partner designing, building and supporting future ready Microsoft Dynamics.
51-200 employees
H1B Sponsorship
Avantiico has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2024 (1)
2022 (1)
2020 (1)
Funding
Current Stage
Growth StageLeadership Team
L
Lauge Mathiasen
CEO and Co-Founder
D
Daniel McAllister
Chief Financial Officer
Company data provided by crunchbase