Saxon Global
BI Analyst
Saxon Global, Tate, Georgia, United States, 30177
Summary/Objective
Under the direction of the Director of Data and Analytics, the Business Intelligence Analyst is responsible for performing tasks related to project completion including analysis, testing, documentation, problem resolution, and implementation of solutions as they apply to the organization's strategy. Responsible for performing tasks related to report and etl development including requirements gathering, specification and definition documentation, design, testing, validation, analysis, and maintenance for all reporting projects.
Essential Functions
Create and maintain ETL jobsCreate and maintain reports (SSRS, Tableau, Excel, etc..)Builds solution architecture for both business intelligence and data project work.Locate and identify data needed, profiles to determine quality and appropriateness, understands necessary manipulation and relationships to be established, and recognizes how to transform the data set to establish what is needed for next stage BI and reportingGathers requirements and defines scope independently on projects of all sizes.Facilitates gathering scope in large projects across multiple analysts.Plans projects and provides time and effort estimates based on requirements gathering.Assists other analysts as needed in project planning and time and effort estimation.Mastery of data literacy - able to identify and derive key insights from data.Educate others on key data literacy concepts.Responsible for following data governance and stewardship practices as defined.Performing documentation and discovery associated with these initiatives.Identifying data quality issues while performing data profiling and testing and validation.Able to act as a data steward and resolve issues or work with appropriate parties to have issues resolved and documented.Position Details
Ideal candidate is proficient with SQL, Tableau and/or PowerBIPrevious experience with Microsoft SSIS and Azure Data FactoryAbility to discover insights in large and complex data sets and proactively anticipates business needsStrong SQL experience including joins and subqueries, pivots, aggregate functions, query optimization, etc.Previous experience with maintaining code via repository (TFS, github...etc)Competencies
LeadershipAbility to work Independently.Ability to assess capability gaps and identify new capabilities requiredExperience in providing analysis and reviewsProficient knowledge of the Application Development Life CycleAbility to determine the probability of the occurrence; conduct analysis and root cause of defectFacilitate meetings to gather feedback on requirements and solution resultsProcess map documentationAbility to provide scenarios and/or use casesProficiency with Data Flow DiagramsAbility to facilitate teams to elicit requirementsAbility to perform structured analysis and work with requirements documentation techniques such as use cases and business process modeling techniquesAbility to effectively prioritize, juggle, and manage numerous projects, initiatives, and problem-solving activitiesExcellent communication skills, presentation, and interpersonal skills requiredProject management experienceSupervisory Responsibility
This role has no supervisory responsibility.
Technical Skills Required
Proven technical writing and editing capabilitiesStrong technical documentation experience including requirements definition, test plans and use case scenariosWork Environment & Physical Demands
This position operates in a professional office setting and is largely a sedentary role. However, some filing is necessary and may require the ability to lift files, open filing cabinets and bend or stand on a stool as necessary.
Position & Expected Hours
This is a full-time, salaried exempt position. Typical work hours and days are Monday through Friday, from 8:00 am to 5:00 pm. Some flexibility in hours is allowed, however, the employee must be available during the "core" work hours of 9:30 am to 3:30 pm and must work 37.5 hours each week.
Travel
Travel to our existing and new offices will be required.
Required Education & Experience
High school diploma or GED requiredSome college preferredAt least two years of related experience in or working closely with the IT departmentCombination of education and experience will be considered
Required Skills : Must have extensive PowerBI experience SSIS development Working with AzureBasic Qualification :Additional Skills :
100% remoteBackground Check :YesDrug Screen :YesNotes :Selling points for candidate :100% remoteProject Verification Info :Candidate must be your W2 Employee :YesExclusive to Apex :YesFace to face interview required :NoCandidate must be local :NoCandidate must be authorized to work without sponsorship :YesInterview times set :YesType of project :Assessment/AnalysisMaster Job Title :Data AnalystBranch Code :Atlanta
Under the direction of the Director of Data and Analytics, the Business Intelligence Analyst is responsible for performing tasks related to project completion including analysis, testing, documentation, problem resolution, and implementation of solutions as they apply to the organization's strategy. Responsible for performing tasks related to report and etl development including requirements gathering, specification and definition documentation, design, testing, validation, analysis, and maintenance for all reporting projects.
Essential Functions
Create and maintain ETL jobsCreate and maintain reports (SSRS, Tableau, Excel, etc..)Builds solution architecture for both business intelligence and data project work.Locate and identify data needed, profiles to determine quality and appropriateness, understands necessary manipulation and relationships to be established, and recognizes how to transform the data set to establish what is needed for next stage BI and reportingGathers requirements and defines scope independently on projects of all sizes.Facilitates gathering scope in large projects across multiple analysts.Plans projects and provides time and effort estimates based on requirements gathering.Assists other analysts as needed in project planning and time and effort estimation.Mastery of data literacy - able to identify and derive key insights from data.Educate others on key data literacy concepts.Responsible for following data governance and stewardship practices as defined.Performing documentation and discovery associated with these initiatives.Identifying data quality issues while performing data profiling and testing and validation.Able to act as a data steward and resolve issues or work with appropriate parties to have issues resolved and documented.Position Details
Ideal candidate is proficient with SQL, Tableau and/or PowerBIPrevious experience with Microsoft SSIS and Azure Data FactoryAbility to discover insights in large and complex data sets and proactively anticipates business needsStrong SQL experience including joins and subqueries, pivots, aggregate functions, query optimization, etc.Previous experience with maintaining code via repository (TFS, github...etc)Competencies
LeadershipAbility to work Independently.Ability to assess capability gaps and identify new capabilities requiredExperience in providing analysis and reviewsProficient knowledge of the Application Development Life CycleAbility to determine the probability of the occurrence; conduct analysis and root cause of defectFacilitate meetings to gather feedback on requirements and solution resultsProcess map documentationAbility to provide scenarios and/or use casesProficiency with Data Flow DiagramsAbility to facilitate teams to elicit requirementsAbility to perform structured analysis and work with requirements documentation techniques such as use cases and business process modeling techniquesAbility to effectively prioritize, juggle, and manage numerous projects, initiatives, and problem-solving activitiesExcellent communication skills, presentation, and interpersonal skills requiredProject management experienceSupervisory Responsibility
This role has no supervisory responsibility.
Technical Skills Required
Proven technical writing and editing capabilitiesStrong technical documentation experience including requirements definition, test plans and use case scenariosWork Environment & Physical Demands
This position operates in a professional office setting and is largely a sedentary role. However, some filing is necessary and may require the ability to lift files, open filing cabinets and bend or stand on a stool as necessary.
Position & Expected Hours
This is a full-time, salaried exempt position. Typical work hours and days are Monday through Friday, from 8:00 am to 5:00 pm. Some flexibility in hours is allowed, however, the employee must be available during the "core" work hours of 9:30 am to 3:30 pm and must work 37.5 hours each week.
Travel
Travel to our existing and new offices will be required.
Required Education & Experience
High school diploma or GED requiredSome college preferredAt least two years of related experience in or working closely with the IT departmentCombination of education and experience will be considered
Required Skills : Must have extensive PowerBI experience SSIS development Working with AzureBasic Qualification :Additional Skills :
100% remoteBackground Check :YesDrug Screen :YesNotes :Selling points for candidate :100% remoteProject Verification Info :Candidate must be your W2 Employee :YesExclusive to Apex :YesFace to face interview required :NoCandidate must be local :NoCandidate must be authorized to work without sponsorship :YesInterview times set :YesType of project :Assessment/AnalysisMaster Job Title :Data AnalystBranch Code :Atlanta