What are the responsibilities and job description for the SQL Developer position at BTD (Current)?
*** If you are viewing this opportunity outside of our website and are interested in applying or if you would like to see a list of all our open BTD positions, please go to: www.btdmfg.com***
Company Overview:
BTD is a fast-growing metalworking company. We provide custom metalwork services for some of the world’s top brands. Our 1400 employees work from four facilities throughout the Midwest and Southeast. We invest in our people, our equipment, and our facilities to offer our clients the best value possible. We are also a wholly owned subsidiary of Otter Tail Corporation, a publicly traded company on NASDAQ.
Summary:
Under general supervision is responsible for the development, maintenance, integration, data governance and reporting of all BTD SQL instances supporting multiple production systems including Microsoft CRM, Microsoft Dynamics AX, SharePoint and custom applications using Microsoft SQL Server and the Microsoft Business Intelligence Stack.
Safety is #1 at BTD: Our expectation is that every employee: 1) Strictly follows safety policies, rules and safe work methods. 2) Promptly corrects or reports safety hazards or unsafe conditions. Promptly reports injuries for prompt diagnosis and treatment. 3) Makes regular suggestions for safety process improvements to support continuous improvement in safety.
Essential Functions:
- Manage data warehousing initiatives to support BTD’s Business Intelligence requirements.
- Provides daily support on all Business Intelligence projects.
- Perform typical SQL Server maintenance and management.
- Work with Server Team to build and deploy new SQL instances across the infrastructure.
- Suggest and deliver new systems and improvements to current technologies.
- Initiate and lead projects from start to finish using sound project management skills.
- Works within safety guidelines at all times.
- Document and monitor internal key controls for compliance with applicable processes, laws, and regulations.
- Other duties as required.
Qualifications, Knowledge, Skills and Abilities:
BS degree in Computer Science or related field from an accredited college. Minimum five years directly related experience.
Experience and Skills Required:
- Extensive knowledge with Microsoft SQL Server Database Administration and performance analysis.
- Extensive experience working with Microsoft SQL Server Management Studio, SQL Server Analysis Services, SQL Server Reporting Services and SQL Server Integration Services.
- Extensive experience working with Azure Data products.
- Proficient in building and executing MSSQL queries for analysis purposes.
- Experience with Microsoft SQL Server clustering technologies.
- Experience working in Visual Studio.
- Experience working with Microsoft Dynamics AX/CRM or SharePoint a plus.
- Ability to communicate effectively, orally and in writing, and have good public relations skills.
- Ability to establish and maintain effective working relationships with others.
Physical Demands: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
While performing the duties of the job, the employee is occasionally required to stand; walk; sit; use hands to finger, handle or feel objects, tools, or controls; reach with hands and arms; climb stairs; balance; stoop, kneel, crouch or crawl; talk or hear; taste or smell. The employee must occasionally lift and/or move up to 50 pounds. Specific vision abilities required by the job include close vision, distance vision, color vision, peripheral vision, depth perception and the ability to adjust focus.
Work Environment: 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. While performing the duties of the job, the employee may be exposed to weather conditions. The noise level in the work environment is usually moderate.
(EO/AAMet/Disability Employer)
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)
Salary : $84,900 - $107,000