Business Intelligence Developer

We need to output HTML fragment with sections: h3 headings for sections present. Must not repeat job title. Must not include Job ID etc. Must include only sections with real content. Must not include boilerplate like EEO, etc. Must remove navigation/legal/EEO etc. Must preserve substantive info. We need to parse the posting. Content: - Intro: "Why Choose Suddath to “Move” your Career to the Next Level? At Suddath, you can be part of something special and inclusive! Join a team that has a 100+ year reputation for excellence as an innovative, growing and financially stable company that is dedicated to promoting a culture that thrives on inclusion and diversity. From numerous awards to being recognized as one of the best places to work, Suddath offers a caring, family environment while providing relocation and logistics services to people and companies all around the world." - "What We Offer! A competitive wage with a comprehensive benefits package, including a 401(k) plan with company matchingWeekly pay for hourly-paid employees. Biweekly pay for salaried employees.Paid Time Off (PTO) and paid company holidaysA tuition reimbursement plan where employees are encouraged to continue their education and developmentFor more information on our benefit offerings, please visit https://suddath.com/about/careers/ and scroll down to view our employee benefits." - "Summary This position will be responsible for the design, development, maintenance and enhancement of BI solutions. You will become familiar with data and business processes supported by the data warehouse and operational applications. This role will be responsible for tracking the work assigned, resolving technical issues and estimating and scheduling tasks. Daily activities will include reviewing existing production reports, participating in daily planning meetings, providing estimates, handling ad-hoc requests, and tracking and communicating daily progress on projects and initiatives. This position will also take on various responsibilities throughout the department as assigned." - "Essential Duties And Responsibilities Work with a variety of data sources (SQL Server, Oracle, Azure SQL)Develop complex dashboards, visualizations, dynamic reports, and scorecards using Power BI and DAX.Optimize report performance and enhance reporting environment.Participate in reporting projects tasks, estimate efforts, scheduling tasks and driving project deliverables and schedules.Support requirements gathering from business users, review and refine requirements.Assist the manager in driving department initiatives.Communicate project status with management.Document standards, guidelines and processes for BI development and support.Ensure that Reporting, guidelines and processes are followed.Resolve technical issues in the report environment and provide alternate solutions." - "QUALIFICATONS To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Education & Experience: One plus years related experience and/or training in logistics industry or closely related; or equivalent combination of education and experience. Knowledge, Skills, and abilities: 1+ years of experience working in analytics or BI development. 1+ years of experience with Microsoft SQL Server, and Microsoft Power BI is preferred Experience working with various data sources (SQL and Oracle database, flat files (csv, delimited), Web API, XML, EDI.) Experience with T-SQL skills preferred. Solid understanding of relational databases and business data; ability to write SQL queries against variety of data sources (OLTP, Data Warehouse). Experience communicating clearly and concisely to individuals from various backgrounds. Ability to influence others through verbal and written communication. Ability to learn new technology and quickly adapt to technology changes." - "PHYSICAL/ENVIRONMENTAL DEMANDS The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Physical Activity Level: While performing the duties of this Job, the employee is regularly required to stand, walk, sit, use hands to finger, handle, or feel, see clearly and talk or hear. The employee must occasionally lift and/or move up to 10 pounds unassisted. Working Conditions: Noise level in the work environment is usually moderate. Work is performed climate-controlled environment in an office setting with adequate ventilation. Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice. The Suddath Companies is a multifaceted group of companies that specialize in worldwide corporate employee relocations, household moving, warehouse and logistics management and specialized transportation services." - Then EEO boilerplate: "The Suddath Companies provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws." We need to remove EEO/legal boilerplate. Also remove navigation/cookie etc (none). Also remove duplicated lines. We need to decide sections: About the role? Could be intro. "Why Choose Suddath..." could be About the company/role. Could be "About the role" or "About Suddath". The instruction: use h3 for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). We should map content to these headings. We have: - Intro about company and why choose Suddath: could be "About the role" or maybe "About Suddath". Since they said "About the role" as example, we can use that. - "What We Offer!" includes benefits, pay schedule (weekly/biweekly), PTO, tuition reimbursement, 401k matching. So we can have sections: Benefits, Pay, maybe Schedule? Pay schedule is weekly/biweekly. Could be under Pay. Benefits: 401k, PTO, holidays, tuition reimbursement. Could also include "Benefits" section. - Summary: could be "Responsibilities" or "Summary". Might be better as "Responsibilities". But we also have "Essential Duties And Responsibilities" which is more detailed. So we could have "Responsibilities" covering both summary and essential duties? But we need to avoid duplication. Perhaps we put summary under "About the role" and essential duties under "Responsibilities". Or we could combine. - Qualifications: we have "QUALIFICATONS" (typo). That is qualifications. Could be "Qualifications" heading. - Skills: maybe part of qualifications. Could separate "Skills" but we have knowledge, skills, abilities. Could put under "Qualifications" or "Skills". The instruction says prefer few substantive sections over many thin ones. So we can combine qualifications and skills into one "Qualifications" section. - Physical/Environmental Demands: maybe not a standard heading; could be omitted if not requested. The instruction says include a section ONLY when posting has real, specific content for it. It does have content. But we don't have a standard heading for that; we could use "Working Conditions" but not in list. Could we create a custom heading? The instruction says use h3 for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). It gives examples but not exclusive? It says use h3 for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). Likely they expect only those headings. So we should not create other headings like Physical/Environmental Demands. We could fold that info into "Responsibilities" or "Working Conditions" not listed. Better to omit if not matching allowed headings. However we must preserve ALL substantive information; we cannot drop it unless we incorporate into allowed sections. Could we put physical demands under "Responsibilities"? Not appropriate. Could we put under "Requirements"? Not really. Could we put under "Qualifications"? Not really. Could we put under "Benefits"? No. Maybe we can create a section "Working Conditions" as h3 even though not in examples? The instruction says use h3 for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). The "e.g." suggests those are examples, not exhaustive. So we can use other headings as needed, but must be h3. However they also say "Prefer a few substantive sections over many thin ones." So we could add a "Working Conditions" section if needed. But we also have "PHYSICAL/ENVIRONMENTAL DEMANDS" which is substantive. We could include as a section "Working Conditions". That seems appropriate. We also have a line about "Please note this job description is not designed to cover..." which is boilerplate; we can drop. We also have "The Suddath Companies is a multifaceted group..." which is company description; could be part of "About the role". Already have intro. We need to remove EEO paragraph. Now craft HTML. Structure:

About the role

Why Choose Suddath to “Move” your Career to the Next Level? At Suddath, you can be part of something special and inclusive! Join a team that has a 100+ year reputation for excellence as an innovative, growing and financially stable company that is dedicated to promoting a culture that thrives on inclusion and diversity. From numerous awards to being recognized as one of the best places to work, Suddath offers a caring, family environment while providing relocation and logistics services to people and companies all around the world. The Suddath Companies is a multifaceted group of companies that specialize in worldwide corporate employee relocations, household moving, warehouse and logistics management and specialized transportation services.

Responsibilities

This position will be responsible for the design, development, maintenance and enhancement of BI solutions. You will become familiar with data and business processes supported by the data warehouse and operational applications. This role will be responsible for tracking the work assigned, resolving technical issues and estimating and scheduling tasks. Daily activities will include reviewing existing production reports, participating in daily planning meetings, providing estimates, handling ad-hoc requests, and tracking and communicating daily progress on projects and initiatives. This position will also take on various responsibilities throughout the department as assigned.

• Work with a variety of data sources (SQL Server, Oracle, Azure SQL)
• Develop complex dashboards, visualizations, dynamic reports, and scorecards using Power BI and DAX
• Optimize report performance and enhance reporting environment
• Participate in reporting projects tasks, estimate efforts, scheduling tasks and driving project deliverables and schedules
• Support requirements gathering from business users, review and refine requirements
• Assist the manager in driving department initiatives
• Communicate project status with management
• Document standards, guidelines and processes for BI development and support
• Ensure that reporting guidelines and processes are followed
• Resolve technical issues in the report environment and provide alternate solutions

Qualifications

Education & Experience: One plus years related experience and/or training in logistics industry or closely related; or equivalent combination of education and experience.

• 1+ years of experience working in analytics or BI development
• 1+ years of experience with Microsoft SQL Server, and Microsoft Power BI is preferred
• Experience working with various data sources (SQL and Oracle database, flat files (csv, delimited), Web API, XML, EDI)
• Experience with T-SQL skills preferred
• Solid understanding of relational databases and business data; ability to write SQL queries against variety of data sources (OLTP, Data Warehouse)
• Experience communicating clearly and concisely to individuals from various backgrounds
• Ability