Skip to Main Content

Senior BI Developer

Saicon Consultants Inc. Atlanta, GA

  • Expired: September 01, 2020. Applications are no longer accepted.

Primary Skills Experience in development of BIData Warehouse solutions Strong knowledge of Data Warehouse processes and Tabular Modeling concepts, with star and snowflake data models Strong skills in utilizing the Microsoft BI stack including Power BI Pro, SQL Server Reporting Services (SSRS), and SQL Server Integration Series (SSIS) to deliver BI Solutions. SQL 2012 required and SQL 2017 or later preferred. Experience with Azure Data Factory is a plus.

Strong T-SQL and DAX skills including advanced coding and performance and tuning Experience in dealing with complex and dirty data sources originating in multiple formats Experience with data modeling, data analysis, data profiling and data mapping Experience with predictive and prescriptive analytics is a plus Responsibilities The Senior Business Intelligence (BI) Developer will assist in the design, development, and administrative control of all BI data extracts and reporting activity for Fulton County Schools. The developer uses critical thinking and analytical skills to plan, design, develop, test, coordinate, and implement business intelligence (BI) solutions for the District. Analyses business, functional, and related issues to formulate and develop new or modified BI solutions.

Creates interfaces to exchange data to and from external systems. Coordinates solution test activities, analyses test results, takes appropriate actions and completes the system documentation. Works directly with business owners to gather requirements and specifications.

Performs quality assurance within the BI environment. Consults with supervisor, business users, business analysts, and other developers to gather information about solution intent, functions, features, data requirements, input requirements, output requirements, internal and external checks and controls, hardware and operating system environment, and interfaces with other systems Works independently to gather requirements, defines designs, configures, develops, tests, and debugs solutions that may include Extract, Transform, and Load (ETL) packages that implement complex ETL processes from data in multiple formats and BI reporting. Ensures quality and accuracy of the data mapped from staging environments to the Data Warehouse and to external interfaces.

Ensures that all solutions perform optimally and are tuned for maximum efficiency. Enhances and maintains the Tabular model supporting BI reporting Provides monitoring and support of existing production ETL jobs. Participates and leads in resolution of errors and issues Creates end to end test transactions, confirms solutions meets specifications, and identifies and resolves errors Writes and maintains documentation of changes to solutions and specifications Trains end users or technical support staff to use and support reports and processes Maintains a proactive view of future demands from business user's including incremental or minor fixes that should be implemented in the short-term Maximizes productivity through good time management, coordination and communication with others, and commitment to set personal goals and meet delivery dates Supports District's operational units as assigned Job Details A minimum of 5 years of experience in development of BIData Warehouse solutions Strong knowledge of Data Warehouse processes and Tabular Modeling concepts, with star and snowflake data models Strong skills in utilizing the Microsoft BI stack including Power BI Pro, SQL Server Reporting Services (SSRS), and SQL Server Integration Series (SSIS) to deliver BI Solutions.

SQL 2012 required and SQL 2017 or later preferred. Experience with Azure Data Factory is a plus. Strong T-SQL and DAX skills including advanced coding and performance and tuning Experience in dealing with complex and dirty data sources originating in multiple formats Experience with data modeling, data analysis, data profiling and data mapping Experience with predictive and prescriptive analytics is a plus Must have an understanding of general business practices, business analysis, requirements gathering Must have superior problem solving skills and techniques to resolve issues that arise with complex business systems Proven experience working with business stakeholders to understand their business intelligence needs and delivering those needs Must be able to collaborate effectively with District personnel and work with diverse groups of people Must be able to successfully manage multiple tasks, projects, and responsibilities Demonstrated ability to work in cross-functional teams as well as independent setting.

Be self-driven with the desire to achieve measurable, specific results within tight time frames. Ability to work under pressure to resolve critical production issues. Excellent written and verbal communication skills Experience with Agile development methodology preferred.

Experience working in an educational environment preferred. Attendance or parental involvement in an American school district is required. We have found that this helps in their understanding of our business processes.

Please respond at the earliest to speed up the interview process. I will contact you if I need further details.

Saicon Consultants Inc.

Saicon Consultants Inc.'s Logo

Address

Atlanta, GA
30301 USA

Industry

Technology

View all jobs at Saicon Consultants Inc.