Consultant, Senior Database Developer

 Overview 

Artic Consulting is expanding our organization, building a values-driven global organization known for our commitment to excellence and business impact, outstanding working relationships with clients and team members, and leading-edge knowledge in business consulting and technology solutions. 

We have an immediate opening for a Consultant, Data & Business Insights Report Developer position, to join our team. This is a full-time, direct-hire position. 

Description and Responsibilities 

We are seeking a skilled and experienced Database Developer to join our team. This role requires strong expertise in managing, troubleshooting, and improving an application built with a front end in Microsoft Access and back end in SQL Server. Candidates with AFRS (Agency Financial Reporting System) experience are highly preferred. 

This is an opportunity to work on an enterprise-level reporting engine across a variety of teams to make immediate impact within a innovative organization. 

• Work with our client and implementation teams from concept to operations, providing deep technical subject matter expertise for successfully deploying large data solutions in the enterprise, using modern data/analytics technologies in both on premise and cloud environments. 
• Design and build supporting framework for reporting utilizing Microsoft Power BI 
• Proficiency in T-SQL, with the ability to understand, formulate and create efficient queries, views and stored procedures, ad-hoc requests and reports. 
• Design, develop, and implement reports, dashboards and KPI scorecards using Power BI in alignment to business requirements. 
• Create and maintain technical documentation including data models, data workflow diagrams and design documents. 
• Collaborate with the Data Insights & Analytics team and other IT resources throughout the development lifecycle; enforcing best practices where necessary. 
• Analytically come up with improved and more efficient processes for IT and business users. 
• Participate in teams to deliver new BI and Analytics solutions or enhance current ones. 
• Provide support for existing applications and services provided by the Data Insights & Analytics team. 
• Investigate and troubleshoot problems. Collaborate with business units and team members to determine root cause and appropriate functional solutions. 
• A solid understanding of security models in Power BI and the ability to implement row level restrictions. 
• Ability to work independently, manage multiple tasks and meet delivery commitments while maintaining accuracy. 
• Proven analytical thinking for translating data into informative visuals and reports. 

Required Qualifications :

• Bachelor’s Degree or equivalent in Business Administration, Communications, or a technical field. 
• Demonstrate experience managing stakeholders’ expectations and effectively mitigating dissatisfied stakeholders  
• Examples of architecting and implementing next generation data and analytics platforms on Power BI. 
• 5 years of data development and reporting experience including data analysis, design and modeling. 
• Minimum 5 years of hands-on experience designing and developing dashboards and reports; 3 years using Power BI. 
• Power BI certification is a definite asset. 
• A minimum of 5 years of experience in Microsoft Access database maintenance and troubleshooting. 
• At least 3 years of experience with AFRS (preferably in Washington). 
• Strong analytical and problem-solving skills for troubleshooting database issues. 
• Excellent understanding of database security and data protection policies. 
• Ability to work independently and manage multiple tasks efficiently. 
• Effective communication skills for collaborating with technical and non-technical teams. 
• Writing Visual Basic code that interfaces between Microsoft Access, Outlook, and Excel.
• Demonstrating a minimum of 5 years of relevant experience with writing Visual Basic code

Preferred Skills:

• Ability to perform in-depth debugging of VBA code, SQL queries, and database components to ensure high performance and functionality. 
• Troubleshoot and resolve data integrity issues, error handling, and performance bottlenecks in Access databases. 
• Use tools like Access Debugger, SQL Server Profiler, and Access’s built-in debugging tools to find and fix issues. 
• Optimize database performance by designing efficient data structures, indexing strategies, and query optimization techniques.

Professional Skills:

• Prior consulting experience a plus 
• Effective communication and presentation skills 
• Keen sense of ownership, teaming attitude, and ability work across a distributed organization 
• Ability to build, manage, and foster a team-oriented environment  
• Ability to work creatively and analytically in a problem-solving environment  
• Relentless proactive planning to eliminate issues and downtime.  
• Constant innovation to make Artic better and faster.  
• Ability to get ahead of the curve with innovative technologies and learn quickly 
• Ability to travel as necessary 

Equal Employment Opportunity:

Artic Consulting is an EEO and Affirmative Action Employer of Females/Minorities/Veterans/Individuals with Disabilities.  
All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by federal, state, or local law.  
Artic is committed to providing veteran employment opportunities to our service men and women.  
Job candidates will not be obligated to disclose sealed or expunged records of conviction or arrest as part of the hiring.  

Benefits:

Join Artic and you will benefit from outstanding professional support and investment in your development.  You will have the opportunity to learn from and be coached by the best in the business – supportive leaders and colleagues who can pass on their industry, technical and functional expertise.   
This also includes medical, dental, vision, and life insurance benefits, 401k, vacation, and annual review process.  All employees of Artic Consulting receive a training credit each year for self-development.